The investor's portfolio example will demonstrate the ability of Teiid to integrate multiple datasources so that a single query can return results from 1 or more of those sources.   This data federation ability can make data integration of new sources easier without having to expose any new access details. 

In this example, 2 datasources will be used;  Account Information, stored in a H2 database, and Market Data (Stock prices), stored in a CSV text file.  The VDB, which we will call DynamicPortfolio, will define a model for each data source; Account and MarketData, respectively.  The VDB will be deployed to the Teiid Runtime, thereby, making it accessible to the user application using JDBC.   To read about all the options for connecting to your VDB, see the Client Developer's Guide.


When the test query is executed that joins data from the Accounts and MarketData models, Teiid will access both, the relational and non-relational sources, calculate the portfolio values, and return the results.